Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Phone No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PHONE NO.

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Phone No.
2	1	Company Information	Phone No.
3	14	Salespersons/Purchasers	Phone No.
4	21	Customer Card	Phone No.
5	22	Customer List	Phone No.
6	26	Vendor Card	Phone No.
7	27	Vendor List	Phone No.
8	33	Customer Lookup	Phone No.
9	34	Vendor Lookup	Phone No.
10	300	Ship-to Address	Phone No.
11	300	Ship-to Address	Phone No.
12	301	Ship-to Address List	Phone No.
13	368	Order Address	Phone No.
14	368	Order Address	Phone No.
15	369	Order Address List	Phone No.
16	370	Bank Account Card	Phone No.
17	371	Bank Account List	Phone No.
18	423	Customer Bank Account Card	Phone No.
19	424	Customer Bank Account List	Phone No.
20	425	Vendor Bank Account Card	Phone No.
21	426	Vendor Bank Account List	Phone No.
22	1165	COHUB Enviroment Card	Phone No.
23	1166	COHUB Enviroment List	Phone No.
24	1283	Payment Bank Account Card	Phone No.
25	1382	Customer Templ. Card	Phone No.
26	1386	Vendor Templ. Card	Phone No.
27	1803	Assisted Company Setup Wizard	Phone No.
28	2101	O365 Customer Activity Page	Phone No.
29	2107	O365 Sales Customer Card	Phone No.
30	2108	O365 Outstanding Customer List	Phone No.
31	2116	O365 Customer Lookup	Phone No.
32	2130	O365 Business Info Settings	Phone No.
33	2179	O365 Contact Lookup	Phone No.
34	2318	BC O365 Sales Customer Card	Phone No.
35	2330	BC O365 Business Info Settings	Phone No.
36	2368	Remit Address	Phone No.
37	2368	Remit Address	Phone No.
38	2369	Remit Address List	Phone No.
39	2379	BC O365 Contact Lookup	Phone No.
40	5050	Contact Card	Phone No.
41	5052	Contact List	Phone No.
42	5054	Company Details	Phone No.
43	5056	Contact Alt. Address Card	Phone No.
44	5057	Contact Alt. Address List	Phone No.
45	5116	Salesperson/Purchaser Card	Phone No.
46	5200	Employee Card	Phone No.
47	5201	Employee List	Phone No.
48	5203	Alternative Address Card	Phone No.
49	5204	Alternative Address List	Phone No.
50	5209	Employee Relatives	Phone No.
51	5213	Unions	Phone No.
52	5703	Location Card	Phone No.
53	5714	Responsibility Center Card	Phone No.
54	5900	Service Order	Phone No.
55	5964	Service Quote	Phone No.
56	5975	Posted Service Shipment	Phone No.
57	5980	Service Item Card	Phone No.
58	6050	Service Contract	Phone No.
59	6053	Service Contract Quote	Phone No.
60	6072	Filed Service Contract	Phone No.
61	9084	Customer Details FactBox	Phone No.
62	9093	Vendor Details FactBox	Phone No.
63	9150	My Customers	Phone No.
64	9151	My Vendors	Phone No.

Dynamics 365 BC Table ReferencePage Control Search